﻿-- ===============================================================================================
-- Basic View for Gender
-- ===============================================================================================

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[esf_sso].[VGender]'))
	DROP VIEW [esf_sso].[VGender]
GO

-- SELECT * FROM [esf_sso].[VGender]

CREATE VIEW [esf_sso].[VGender] AS
	SELECT * FROM esf_sso.VBasicReference WHERE BasicReferenceTypeID = 2
	
GO 